package com.info.zhiduoduo.repository.mapper.quota;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.info.zhiduoduo.repository.dto.quota.CompanyQuotaDto;
import com.info.zhiduoduo.repository.entity.quota.CompanyQuota;

import org.apache.ibatis.annotations.Select;

public interface CompanyQuotaMapper extends BaseMapper<CompanyQuota> {

	@Select(" select cq.*,c.quota_flag " +
			" from zdd_company c " +
			" left join zdd_company_quota cq on c.compid = cq.compid " +
			" where c.compid = #{compid}")
	CompanyQuotaDto getByCompid(Integer compid);
}
